{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Menu","Colab - Previsto","Colab - Realizado","Previsto Realizado","CG","Holerite","Dash","Instruções","Lista"],"not_rendered":{"charts":3,"images":12,"macros":1,"external_links":2,"defined_names":19,"comments":0,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,4,25,5],[25,6,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Empresa:",null,"Empresa ABCDE"]

{"sheet":"Colab - Previsto","index":1,"n_rows":63,"n_cols":23,"rows_kept":63,"cut":false,"hidden":false,"merged":[[9,4,9,5],[11,2,11,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Empresa:","Empresa ABCDE"]
[]
[null,null,"CADASTRO DE COLABORADORES\nInsira os dados previstos dos seus colaboradores."]
[null,"Matrícula","Colaborador","CBO","Área","Cargo","Salário Base","Data Admissão","Hora Extra 50%","Hora Extra 100%","Valor Hora Extra","% Insalubridade","Valor Insalubridade","% Periculosidade","Valor Periculosidade","Salário Bruto","INSS","IR","Outras Deduções","Outras Receitas","Salário Líquido","Mês Referência","Ano Referência"]
[null,9001,"José da Silva",1234,"Administrativo","Assistente Administrativo",2500,"2020-02-01",1,5,{"$f":"SUM((G14/220)*I14*1.5,(G14/220)*J14*2)","v":130.68181818181819},0,{"$f":"IF(L14=\"\",0,G14*L14)","v":0},0,{"$f":"IF(N14=\"\",0,G14*N14)","v":0},{"$f":"G14+K14+M14+O14","v":2630.681818181818},{"$f":"IFERROR(P14*VLOOKUP(P14,CG!$B$16:$C$19,2,1),0)","v":236.76136363636363},{"$f":"(P14-Q14-S14)*VLOOKUP((P14-Q14-S14),CG!$E$16:$G$20,2,1)-VLOOKUP((P14-Q14-S14),CG!$E$16:$G$20,3,1)","v":36.744034090909082},null,null,{"$f":"P14-Q14-R14-S14+T14","v":2357.1764204545452},"Janeiro",2021]
[null,9002,"João Alves",5678,"Produção","Auxiliar de PCP",1200,"2019-10-15",3,2,{"$f":"SUM((G15/220)*I15*1.5,(G15/220)*J15*2)","v":46.36363636363636},0,{"$f":"IF(L15=\"\",0,G15*L15)","v":0},0,{"$f":"IF(N15=\"\",0,G15*N15)","v":0},{"$f":"G15+K15+M15+O15","v":1246.3636363636363},{"$f":"IFERROR(P15*VLOOKUP(P15,CG!$B$16:$C$19,2,1),0)","v":93.47727272727272},{"$f":"(P15-Q15-S15)*VLOOKUP((P15-Q15-S15),CG!$E$16:$G$20,2,1)-VLOOKUP((P15-Q15-S15),CG!$E$16:$G$20,3,1)","v":0},null,null,{"$f":"P15-Q15-R15-S15+T15","v":1152.8863636363635},"Fevereiro",2021]
[null,9003,"Paulo Vitor",6789,"Almoxarifado","Almoxarife",1500,"2019-05-10",10,2,129.54545454545456,0.1,150,0.2,300,2079.5454545454545,{"$f":"IFERROR(P16*VLOOKUP(P16,CG!$B$16:$C$19,2,1),0)","v":155.96590909090909},{"$f":"(P16-Q16-S16)*VLOOKUP((P16-Q16-S16),CG!$E$16:$G$20,2,1)-VLOOKUP((P16-Q16-S16),CG!$E$16:$G$20,3,1)","v":1.4684659090908951},null,null,1922.1110795454547,"Março",2021]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P17*VLOOKUP(P17,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P17-Q17-S17)*VLOOKUP((P17-Q17-S17),CG!$E$16:$G$20,2,1)-VLOOKUP((P17-Q17-S17),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM((G18/220)*I18*1.5,(G18/220)*J18*2)","v":0},null,{"$f":"IF(L18=\"\",0,G18*L18)","v":0},null,{"$f":"IF(N18=\"\",0,G18*N18)","v":0},{"$f":"G18+K18+M18+O18","v":0},{"$f":"IFERROR(P18*VLOOKUP(P18,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P18-Q18-S18)*VLOOKUP((P18-Q18-S18),CG!$E$16:$G$20,2,1)-VLOOKUP((P18-Q18-S18),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P19*VLOOKUP(P19,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P19-Q19-S19)*VLOOKUP((P19-Q19-S19),CG!$E$16:$G$20,2,1)-VLOOKUP((P19-Q19-S19),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P20*VLOOKUP(P20,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P20-Q20-S20)*VLOOKUP((P20-Q20-S20),CG!$E$16:$G$20,2,1)-VLOOKUP((P20-Q20-S20),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P21*VLOOKUP(P21,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P21-Q21-S21)*VLOOKUP((P21-Q21-S21),CG!$E$16:$G$20,2,1)-VLOOKUP((P21-Q21-S21),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P22*VLOOKUP(P22,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P22-Q22-S22)*VLOOKUP((P22-Q22-S22),CG!$E$16:$G$20,2,1)-VLOOKUP((P22-Q22-S22),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P23*VLOOKUP(P23,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P23-Q23-S23)*VLOOKUP((P23-Q23-S23),CG!$E$16:$G$20,2,1)-VLOOKUP((P23-Q23-S23),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P24*VLOOKUP(P24,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P24-Q24-S24)*VLOOKUP((P24-Q24-S24),CG!$E$16:$G$20,2,1)-VLOOKUP((P24-Q24-S24),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P25*VLOOKUP(P25,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P25-Q25-S25)*VLOOKUP((P25-Q25-S25),CG!$E$16:$G$20,2,1)-VLOOKUP((P25-Q25-S25),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P26*VLOOKUP(P26,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P26-Q26-S26)*VLOOKUP((P26-Q26-S26),CG!$E$16:$G$20,2,1)-VLOOKUP((P26-Q26-S26),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P27*VLOOKUP(P27,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P27-Q27-S27)*VLOOKUP((P27-Q27-S27),CG!$E$16:$G$20,2,1)-VLOOKUP((P27-Q27-S27),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P28*VLOOKUP(P28,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P28-Q28-S28)*VLOOKUP((P28-Q28-S28),CG!$E$16:$G$20,2,1)-VLOOKUP((P28-Q28-S28),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P29*VLOOKUP(P29,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P29-Q29-S29)*VLOOKUP((P29-Q29-S29),CG!$E$16:$G$20,2,1)-VLOOKUP((P29-Q29-S29),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P30*VLOOKUP(P30,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P30-Q30-S30)*VLOOKUP((P30-Q30-S30),CG!$E$16:$G$20,2,1)-VLOOKUP((P30-Q30-S30),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P31*VLOOKUP(P31,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P31-Q31-S31)*VLOOKUP((P31-Q31-S31),CG!$E$16:$G$20,2,1)-VLOOKUP((P31-Q31-S31),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P32*VLOOKUP(P32,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P32-Q32-S32)*VLOOKUP((P32-Q32-S32),CG!$E$16:$G$20,2,1)-VLOOKUP((P32-Q32-S32),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P33*VLOOKUP(P33,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P33-Q33-S33)*VLOOKUP((P33-Q33-S33),CG!$E$16:$G$20,2,1)-VLOOKUP((P33-Q33-S33),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P34*VLOOKUP(P34,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P34-Q34-S34)*VLOOKUP((P34-Q34-S34),CG!$E$16:$G$20,2,1)-VLOOKUP((P34-Q34-S34),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P35*VLOOKUP(P35,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P35-Q35-S35)*VLOOKUP((P35-Q35-S35),CG!$E$16:$G$20,2,1)-VLOOKUP((P35-Q35-S35),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P36*VLOOKUP(P36,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P36-Q36-S36)*VLOOKUP((P36-Q36-S36),CG!$E$16:$G$20,2,1)-VLOOKUP((P36-Q36-S36),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P37*VLOOKUP(P37,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P37-Q37-S37)*VLOOKUP((P37-Q37-S37),CG!$E$16:$G$20,2,1)-VLOOKUP((P37-Q37-S37),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P38*VLOOKUP(P38,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P38-Q38-S38)*VLOOKUP((P38-Q38-S38),CG!$E$16:$G$20,2,1)-VLOOKUP((P38-Q38-S38),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P39*VLOOKUP(P39,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P39-Q39-S39)*VLOOKUP((P39-Q39-S39),CG!$E$16:$G$20,2,1)-VLOOKUP((P39-Q39-S39),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P40*VLOOKUP(P40,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P40-Q40-S40)*VLOOKUP((P40-Q40-S40),CG!$E$16:$G$20,2,1)-VLOOKUP((P40-Q40-S40),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P41*VLOOKUP(P41,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P41-Q41-S41)*VLOOKUP((P41-Q41-S41),CG!$E$16:$G$20,2,1)-VLOOKUP((P41-Q41-S41),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P42*VLOOKUP(P42,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P42-Q42-S42)*VLOOKUP((P42-Q42-S42),CG!$E$16:$G$20,2,1)-VLOOKUP((P42-Q42-S42),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P43*VLOOKUP(P43,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P43-Q43-S43)*VLOOKUP((P43-Q43-S43),CG!$E$16:$G$20,2,1)-VLOOKUP((P43-Q43-S43),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P44*VLOOKUP(P44,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P44-Q44-S44)*VLOOKUP((P44-Q44-S44),CG!$E$16:$G$20,2,1)-VLOOKUP((P44-Q44-S44),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P45*VLOOKUP(P45,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P45-Q45-S45)*VLOOKUP((P45-Q45-S45),CG!$E$16:$G$20,2,1)-VLOOKUP((P45-Q45-S45),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P46*VLOOKUP(P46,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P46-Q46-S46)*VLOOKUP((P46-Q46-S46),CG!$E$16:$G$20,2,1)-VLOOKUP((P46-Q46-S46),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P47*VLOOKUP(P47,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P47-Q47-S47)*VLOOKUP((P47-Q47-S47),CG!$E$16:$G$20,2,1)-VLOOKUP((P47-Q47-S47),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P48*VLOOKUP(P48,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P48-Q48-S48)*VLOOKUP((P48-Q48-S48),CG!$E$16:$G$20,2,1)-VLOOKUP((P48-Q48-S48),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P49*VLOOKUP(P49,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P49-Q49-S49)*VLOOKUP((P49-Q49-S49),CG!$E$16:$G$20,2,1)-VLOOKUP((P49-Q49-S49),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P50*VLOOKUP(P50,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P50-Q50-S50)*VLOOKUP((P50-Q50-S50),CG!$E$16:$G$20,2,1)-VLOOKUP((P50-Q50-S50),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P51*VLOOKUP(P51,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P51-Q51-S51)*VLOOKUP((P51-Q51-S51),CG!$E$16:$G$20,2,1)-VLOOKUP((P51-Q51-S51),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P52*VLOOKUP(P52,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P52-Q52-S52)*VLOOKUP((P52-Q52-S52),CG!$E$16:$G$20,2,1)-VLOOKUP((P52-Q52-S52),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P53*VLOOKUP(P53,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P53-Q53-S53)*VLOOKUP((P53-Q53-S53),CG!$E$16:$G$20,2,1)-VLOOKUP((P53-Q53-S53),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P54*VLOOKUP(P54,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P54-Q54-S54)*VLOOKUP((P54-Q54-S54),CG!$E$16:$G$20,2,1)-VLOOKUP((P54-Q54-S54),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P55*VLOOKUP(P55,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P55-Q55-S55)*VLOOKUP((P55-Q55-S55),CG!$E$16:$G$20,2,1)-VLOOKUP((P55-Q55-S55),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P56*VLOOKUP(P56,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P56-Q56-S56)*VLOOKUP((P56-Q56-S56),CG!$E$16:$G$20,2,1)-VLOOKUP((P56-Q56-S56),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P57*VLOOKUP(P57,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P57-Q57-S57)*VLOOKUP((P57-Q57-S57),CG!$E$16:$G$20,2,1)-VLOOKUP((P57-Q57-S57),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P58*VLOOKUP(P58,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P58-Q58-S58)*VLOOKUP((P58-Q58-S58),CG!$E$16:$G$20,2,1)-VLOOKUP((P58-Q58-S58),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P59*VLOOKUP(P59,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P59-Q59-S59)*VLOOKUP((P59-Q59-S59),CG!$E$16:$G$20,2,1)-VLOOKUP((P59-Q59-S59),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P60*VLOOKUP(P60,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P60-Q60-S60)*VLOOKUP((P60-Q60-S60),CG!$E$16:$G$20,2,1)-VLOOKUP((P60-Q60-S60),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P61*VLOOKUP(P61,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P61-Q61-S61)*VLOOKUP((P61-Q61-S61),CG!$E$16:$G$20,2,1)-VLOOKUP((P61-Q61-S61),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P62*VLOOKUP(P62,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P62-Q62-S62)*VLOOKUP((P62-Q62-S62),CG!$E$16:$G$20,2,1)-VLOOKUP((P62-Q62-S62),CG!$E$16:$G$20,3,1)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P63*VLOOKUP(P63,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P63-Q63-S63)*VLOOKUP((P63-Q63-S63),CG!$E$16:$G$20,2,1)-VLOOKUP((P63-Q63-S63),CG!$E$16:$G$20,3,1)","v":0},null,null,0]

{"sheet":"Colab - Realizado","index":2,"n_rows":63,"n_cols":24,"rows_kept":63,"cut":false,"hidden":false,"merged":[[9,4,9,5],[11,2,11,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Empresa:","Empresa ABCDE"]
[]
[null,null,"CADASTRO DE COLABORADORES\nInsira os dados previstos dos seus colaboradores."]
[null,"Matrícula","Colaborador","CBO","Área","Cargo","Salário Base","Data Admissão","Hora Extra 50%","Hora Extra 100%","Valor Hora Extra","% Insalubridade","Valor Insalubridade","% Periculosidade","Valor Periculosidade","Salário Bruto","INSS","IR","Outras Deduções","Outras Receitas","Salário Líquido","Mês Referência","Ano Referência","Mês/ano"]
[null,9001,"José da Silva",1234,"Administrativo","Assistente Administrativo",3000,"2020-02-01",1,5,{"$f":"SUM((G14/220)*I14*1.5,(G14/220)*J14*2)","v":156.81818181818181},0,{"$f":"IF(L14=\"\",0,G14*L14)","v":0},0,{"$f":"IF(N14=\"\",0,G14*N14)","v":0},{"$f":"G14+K14+M14+O14","v":3156.818181818182},{"$f":"IFERROR(P14*VLOOKUP(P14,CG!$B$16:$C$19,2,1),0)","v":378.81818181818181},{"$f":"(P14-Q14-S14)*VLOOKUP((P14-Q14-S14),CG!$E$16:$G$20,2,1)-VLOOKUP((P14-Q14-S14),CG!$E$16:$G$20,3,1)","v":65.549999999999983},null,null,{"$f":"P14-Q14-R14-S14+T14","v":2712.45},"Janeiro",2021,{"$f":"CONCATENATE(V14,\"/\",W14)","v":"Janeiro/2021"}]
[null,9002,"João Alves",5678,"Produção","Auxiliar de PCP",2500,"2019-10-15",3,2,{"$f":"SUM((G15/220)*I15*1.5,(G15/220)*J15*2)","v":96.590909090909093},0,{"$f":"IF(L15=\"\",0,G15*L15)","v":0},0,{"$f":"IF(N15=\"\",0,G15*N15)","v":0},{"$f":"G15+K15+M15+O15","v":2596.590909090909},{"$f":"IFERROR(P15*VLOOKUP(P15,CG!$B$16:$C$19,2,1),0)","v":233.69318181818181},{"$f":"(P15-Q15-S15)*VLOOKUP((P15-Q15-S15),CG!$E$16:$G$20,2,1)-VLOOKUP((P15-Q15-S15),CG!$E$16:$G$20,3,1)","v":34.417329545454521},null,null,{"$f":"P15-Q15-R15-S15+T15","v":2328.4803977272727},"Janeiro",2021,"Janeiro/2021"]
[null,9003,"Paulo Vitor",6789,"Almoxarifado","Almoxarife",1500,"2019-05-10",10,2,129.54545454545456,0.1,150,0.2,300,2079.5454545454545,{"$f":"IFERROR(P16*VLOOKUP(P16,CG!$B$16:$C$19,2,1),0)","v":155.96590909090909},{"$f":"(P16-Q16-S16)*VLOOKUP((P16-Q16-S16),CG!$E$16:$G$20,2,1)-VLOOKUP((P16-Q16-S16),CG!$E$16:$G$20,3,1)","v":1.4684659090908951},null,null,1922.1110795454547,"Janeiro",2021,"Janeiro/2021"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P17*VLOOKUP(P17,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P17-Q17-S17)*VLOOKUP((P17-Q17-S17),CG!$E$16:$G$20,2,1)-VLOOKUP((P17-Q17-S17),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P18*VLOOKUP(P18,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P18-Q18-S18)*VLOOKUP((P18-Q18-S18),CG!$E$16:$G$20,2,1)-VLOOKUP((P18-Q18-S18),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P19*VLOOKUP(P19,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P19-Q19-S19)*VLOOKUP((P19-Q19-S19),CG!$E$16:$G$20,2,1)-VLOOKUP((P19-Q19-S19),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P20*VLOOKUP(P20,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P20-Q20-S20)*VLOOKUP((P20-Q20-S20),CG!$E$16:$G$20,2,1)-VLOOKUP((P20-Q20-S20),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P21*VLOOKUP(P21,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P21-Q21-S21)*VLOOKUP((P21-Q21-S21),CG!$E$16:$G$20,2,1)-VLOOKUP((P21-Q21-S21),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P22*VLOOKUP(P22,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P22-Q22-S22)*VLOOKUP((P22-Q22-S22),CG!$E$16:$G$20,2,1)-VLOOKUP((P22-Q22-S22),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P23*VLOOKUP(P23,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P23-Q23-S23)*VLOOKUP((P23-Q23-S23),CG!$E$16:$G$20,2,1)-VLOOKUP((P23-Q23-S23),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P24*VLOOKUP(P24,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P24-Q24-S24)*VLOOKUP((P24-Q24-S24),CG!$E$16:$G$20,2,1)-VLOOKUP((P24-Q24-S24),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P25*VLOOKUP(P25,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P25-Q25-S25)*VLOOKUP((P25-Q25-S25),CG!$E$16:$G$20,2,1)-VLOOKUP((P25-Q25-S25),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P26*VLOOKUP(P26,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P26-Q26-S26)*VLOOKUP((P26-Q26-S26),CG!$E$16:$G$20,2,1)-VLOOKUP((P26-Q26-S26),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P27*VLOOKUP(P27,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P27-Q27-S27)*VLOOKUP((P27-Q27-S27),CG!$E$16:$G$20,2,1)-VLOOKUP((P27-Q27-S27),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P28*VLOOKUP(P28,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P28-Q28-S28)*VLOOKUP((P28-Q28-S28),CG!$E$16:$G$20,2,1)-VLOOKUP((P28-Q28-S28),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P29*VLOOKUP(P29,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P29-Q29-S29)*VLOOKUP((P29-Q29-S29),CG!$E$16:$G$20,2,1)-VLOOKUP((P29-Q29-S29),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P30*VLOOKUP(P30,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P30-Q30-S30)*VLOOKUP((P30-Q30-S30),CG!$E$16:$G$20,2,1)-VLOOKUP((P30-Q30-S30),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P31*VLOOKUP(P31,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P31-Q31-S31)*VLOOKUP((P31-Q31-S31),CG!$E$16:$G$20,2,1)-VLOOKUP((P31-Q31-S31),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P32*VLOOKUP(P32,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P32-Q32-S32)*VLOOKUP((P32-Q32-S32),CG!$E$16:$G$20,2,1)-VLOOKUP((P32-Q32-S32),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P33*VLOOKUP(P33,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P33-Q33-S33)*VLOOKUP((P33-Q33-S33),CG!$E$16:$G$20,2,1)-VLOOKUP((P33-Q33-S33),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P34*VLOOKUP(P34,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P34-Q34-S34)*VLOOKUP((P34-Q34-S34),CG!$E$16:$G$20,2,1)-VLOOKUP((P34-Q34-S34),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P35*VLOOKUP(P35,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P35-Q35-S35)*VLOOKUP((P35-Q35-S35),CG!$E$16:$G$20,2,1)-VLOOKUP((P35-Q35-S35),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P36*VLOOKUP(P36,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P36-Q36-S36)*VLOOKUP((P36-Q36-S36),CG!$E$16:$G$20,2,1)-VLOOKUP((P36-Q36-S36),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P37*VLOOKUP(P37,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P37-Q37-S37)*VLOOKUP((P37-Q37-S37),CG!$E$16:$G$20,2,1)-VLOOKUP((P37-Q37-S37),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P38*VLOOKUP(P38,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P38-Q38-S38)*VLOOKUP((P38-Q38-S38),CG!$E$16:$G$20,2,1)-VLOOKUP((P38-Q38-S38),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P39*VLOOKUP(P39,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P39-Q39-S39)*VLOOKUP((P39-Q39-S39),CG!$E$16:$G$20,2,1)-VLOOKUP((P39-Q39-S39),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P40*VLOOKUP(P40,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P40-Q40-S40)*VLOOKUP((P40-Q40-S40),CG!$E$16:$G$20,2,1)-VLOOKUP((P40-Q40-S40),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P41*VLOOKUP(P41,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P41-Q41-S41)*VLOOKUP((P41-Q41-S41),CG!$E$16:$G$20,2,1)-VLOOKUP((P41-Q41-S41),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P42*VLOOKUP(P42,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P42-Q42-S42)*VLOOKUP((P42-Q42-S42),CG!$E$16:$G$20,2,1)-VLOOKUP((P42-Q42-S42),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P43*VLOOKUP(P43,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P43-Q43-S43)*VLOOKUP((P43-Q43-S43),CG!$E$16:$G$20,2,1)-VLOOKUP((P43-Q43-S43),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P44*VLOOKUP(P44,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P44-Q44-S44)*VLOOKUP((P44-Q44-S44),CG!$E$16:$G$20,2,1)-VLOOKUP((P44-Q44-S44),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P45*VLOOKUP(P45,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P45-Q45-S45)*VLOOKUP((P45-Q45-S45),CG!$E$16:$G$20,2,1)-VLOOKUP((P45-Q45-S45),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P46*VLOOKUP(P46,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P46-Q46-S46)*VLOOKUP((P46-Q46-S46),CG!$E$16:$G$20,2,1)-VLOOKUP((P46-Q46-S46),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P47*VLOOKUP(P47,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P47-Q47-S47)*VLOOKUP((P47-Q47-S47),CG!$E$16:$G$20,2,1)-VLOOKUP((P47-Q47-S47),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P48*VLOOKUP(P48,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P48-Q48-S48)*VLOOKUP((P48-Q48-S48),CG!$E$16:$G$20,2,1)-VLOOKUP((P48-Q48-S48),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P49*VLOOKUP(P49,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P49-Q49-S49)*VLOOKUP((P49-Q49-S49),CG!$E$16:$G$20,2,1)-VLOOKUP((P49-Q49-S49),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P50*VLOOKUP(P50,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P50-Q50-S50)*VLOOKUP((P50-Q50-S50),CG!$E$16:$G$20,2,1)-VLOOKUP((P50-Q50-S50),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P51*VLOOKUP(P51,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P51-Q51-S51)*VLOOKUP((P51-Q51-S51),CG!$E$16:$G$20,2,1)-VLOOKUP((P51-Q51-S51),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P52*VLOOKUP(P52,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P52-Q52-S52)*VLOOKUP((P52-Q52-S52),CG!$E$16:$G$20,2,1)-VLOOKUP((P52-Q52-S52),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P53*VLOOKUP(P53,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P53-Q53-S53)*VLOOKUP((P53-Q53-S53),CG!$E$16:$G$20,2,1)-VLOOKUP((P53-Q53-S53),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P54*VLOOKUP(P54,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P54-Q54-S54)*VLOOKUP((P54-Q54-S54),CG!$E$16:$G$20,2,1)-VLOOKUP((P54-Q54-S54),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P55*VLOOKUP(P55,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P55-Q55-S55)*VLOOKUP((P55-Q55-S55),CG!$E$16:$G$20,2,1)-VLOOKUP((P55-Q55-S55),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P56*VLOOKUP(P56,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P56-Q56-S56)*VLOOKUP((P56-Q56-S56),CG!$E$16:$G$20,2,1)-VLOOKUP((P56-Q56-S56),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P57*VLOOKUP(P57,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P57-Q57-S57)*VLOOKUP((P57-Q57-S57),CG!$E$16:$G$20,2,1)-VLOOKUP((P57-Q57-S57),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P58*VLOOKUP(P58,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P58-Q58-S58)*VLOOKUP((P58-Q58-S58),CG!$E$16:$G$20,2,1)-VLOOKUP((P58-Q58-S58),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P59*VLOOKUP(P59,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P59-Q59-S59)*VLOOKUP((P59-Q59-S59),CG!$E$16:$G$20,2,1)-VLOOKUP((P59-Q59-S59),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P60*VLOOKUP(P60,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P60-Q60-S60)*VLOOKUP((P60-Q60-S60),CG!$E$16:$G$20,2,1)-VLOOKUP((P60-Q60-S60),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P61*VLOOKUP(P61,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P61-Q61-S61)*VLOOKUP((P61-Q61-S61),CG!$E$16:$G$20,2,1)-VLOOKUP((P61-Q61-S61),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P62*VLOOKUP(P62,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P62-Q62-S62)*VLOOKUP((P62-Q62-S62),CG!$E$16:$G$20,2,1)-VLOOKUP((P62-Q62-S62),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]
[null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,0,{"$f":"IFERROR(P63*VLOOKUP(P63,CG!$B$16:$C$19,2,1),0)","v":0},{"$f":"(P63-Q63-S63)*VLOOKUP((P63-Q63-S63),CG!$E$16:$G$20,2,1)-VLOOKUP((P63-Q63-S63),CG!$E$16:$G$20,3,1)","v":0},null,null,0,null,null,"/"]

{"sheet":"Previsto Realizado","index":3,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,4,9,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Ano:",2021,"Empresa:","Empresa ABCDE"]
[]
[null,null,"Janeiro","Fevereiro","Março","Abril","Maio","Junho","Julho","Agosto","Setembro","Outubro","Novembro","Dezembro"]
[null,"Previsto",{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!C$12,'Colab - Previsto'!$U$14:$U$63)","v":2357.1764204545452},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!D$12,'Colab - Previsto'!$U$14:$U$63)","v":1152.8863636363635},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!E$12,'Colab - Previsto'!$U$14:$U$63)","v":1922.1110795454547},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!F$12,'Colab - Previsto'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!G$12,'Colab - Previsto'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!H$12,'Colab - Previsto'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!I$12,'Colab - Previsto'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!J$12,'Colab - Previsto'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!K$12,'Colab - Previsto'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!L$12,'Colab - Previsto'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!M$12,'Colab - Previsto'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Previsto'!$V$14:$V$63,'Previsto Realizado'!N$12,'Colab - Previsto'!$U$14:$U$63)","v":0}]
[null,"Realizado",{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!C$12,'Colab - Realizado'!$U$14:$U$63)","v":6963.0414772727272},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!D$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!E$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!F$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!G$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!H$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!I$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!J$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!K$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!L$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!M$12,'Colab - Realizado'!$U$14:$U$63)","v":0},{"$f":"SUMIF('Colab - Realizado'!$V$14:$V$63,'Previsto Realizado'!N$12,'Colab - Realizado'!$U$14:$U$63)","v":0}]

{"sheet":"CG","index":4,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[9,2,9,5],[13,1,13,2],[13,4,13,6],[22,2,22,8],[23,2,23,8],[11,1,11,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Empresa:","Empresa ABCDE"]
[]
[null,"CADASTROS GERAIS\nInsira as configurações necessárias para os cálculos da folha de pagamento."]
[]
[null,"TABELA INSS",null,null,"TABELA IR"]
[null,"Salário","% INSS",null,"Salário","% IR","Dedução"]
[null,1045,7.4999999999999997E-2,null,0,0,0]
[null,2089.6,0.09,null,1903.98,7.4999999999999997E-2,142.80000000000001]
[null,3134.4,0.12,null,2826.65,0.15,354.8]
[null,6101.06,0.14000000000000001,null,3751.05,0.22500000000000001,636.13]
[null,null,null,null,4664.68,0.27500000000000002,869.36]
[]
[]
[null,"Empresa:",{"$f":"C10","v":"Empresa ABCDE"}]
[null,"CNPJ:"]

{"sheet":"Holerite","index":5,"n_rows":79,"n_cols":17,"rows_kept":79,"cut":false,"hidden":false,"merged":[[4,11,4,12],[4,7,4,9],[45,7,45,9],[45,11,45,12],[2,2,3,5],[2,6,3,12],[2,14,37,14],[3,15,21,15],[4,2,4,5],[10,7,10,9],[10,10,10,12],[11,3,11,5],[11,7,11,9],[11,10,11,12],[12,3,12,5],[12,7,12,9],[12,10,12,12],[13,3,13,5],[13,7,13,9],[13,10,13,12],[21,3,21,5],[21,7,21,9],[21,10,21,12],[18,3,18,5],[18,7,18,9],[18,10,18,12],[19,3,19,5],[4,16,21,16],[5,2,5,12],[6,3,6,5],[7,3,7,5],[8,2,8,12],[9,3,9,5],[9,7,9,9],[9,10,9,12],[10,3,10,5],[16,3,16,5],[16,7,16,9],[16,10,16,12],[17,3,17,5],[17,7,17,9],[17,10,17,12],[14,3,14,5],[14,7,14,9],[14,10,14,12],[15,3,15,5],[15,7,15,9],[15,10,15,12],[20,3,20,5],[20,7,20,9],[20,10,20,12],[19,7,19,9],[19,10,19,12],[24,15,36,15],[24,16,36,16],[25,3,25,5],[25,7,25,9],[25,10,25,12],[26,3,26,5],[26,7,26,9],[22,3,22,5],[22,7,22,9],[22,10,22,12],[23,3,23,5],[23,7,23,9],[23,10,23,12],[26,10,26,12],[27,3,27,5],[27,7,27,9],[27,10,27,12],[28,3,28,5],[28,7,28,9],[28,10,28,12],[24,3,24,5],[24,7,24,9],[24,10,24,12],[29,3,29,5],[29,7,29,9],[29,10,29,12],[30,2,34,6],[30,7,30,9],[30,10,30,12],[31,7,31,9],[31,10,31,12],[32,7,32,12],[33,7,34,9],[33,10,34,12],[36,2,36,3],[36,6,36,7],[36,8,36,10],[36,11,36,12],[37,2,37,3],[37,6,37,7],[37,8,37,10],[37,11,37,12],[48,3,48,5],[49,2,49,12],[50,3,50,5],[50,7,50,9],[50,10,50,12],[40,1,40,17],[43,2,44,5],[43,6,44,12],[43,14,78,14],[44,15,62,15],[45,2,45,5],[45,16,62,16],[46,2,46,12],[47,3,47,5],[53,3,53,5],[53,7,53,9],[53,10,53,12],[54,3,54,5],[54,7,54,9],[54,10,54,12],[51,3,51,5],[51,7,51,9],[51,10,51,12],[52,3,52,5],[52,7,52,9],[52,10,52,12],[57,3,57,5],[57,7,57,9],[57,10,57,12],[58,3,58,5],[58,7,58,9],[58,10,58,12],[55,3,55,5],[55,7,55,9],[55,10,55,12],[56,3,56,5],[56,7,56,9],[56,10,56,12],[61,3,61,5],[61,7,61,9],[61,10,61,12],[62,3,62,5],[62,7,62,9],[62,10,62,12],[59,3,59,5],[59,7,59,9],[59,10,59,12],[60,3,60,5],[60,7,60,9],[60,10,60,12],[65,15,77,15],[65,16,77,16],[66,3,66,5],[66,7,66,9],[66,10,66,12],[67,3,67,5],[67,7,67,9],[63,3,63,5],[63,7,63,9],[63,10,63,12],[64,3,64,5],[64,7,64,9],[64,10,64,12],[67,10,67,12],[68,3,68,5],[68,7,68,9],[68,10,68,12],[69,3,69,5],[69,7,69,9],[69,10,69,12],[65,3,65,5],[65,7,65,9],[65,10,65,12],[70,3,70,5],[77,2,77,3],[77,6,77,7],[77,8,77,10],[77,11,77,12],[78,2,78,3],[78,6,78,7],[78,8,78,10],[78,11,78,12],[70,7,70,9],[70,10,70,12],[71,2,75,6],[71,7,71,9],[71,10,71,12],[72,7,72,9],[72,10,72,12],[73,7,73,12],[74,7,75,9],[74,10,75,12]]}
[]
[]
[null,null,{"$f":"CG!C23","v":"Empresa ABCDE"},null,null,null,"Recibo de Pagamento de Salário",null,null,null,null,null,null,null,"DECLARO TER RECEBIDO  A I MPOTÂNCIA LÍQUIDA DISCRIMINADA NESTE RECIBO\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"________________________________"]
[null,null,{"$f":"CONCATENATE(\"CNPJ: \",CG!C24)","v":"CNPJ: "},null,null,null,null,"Janeiro",null,null,"/",2021,null,null,null,null,"ASSINATURA DO FUNCIONÁRIO"]
[]
[null,null,"Código","Nome do Funcionário",null,null,"CBO","Função"]
[{"$f":"CONCATENATE(H5,\"/\",L5)","v":"Janeiro/2021"},null,9003,{"$f":"IFERROR(VLOOKUP(C8,'Colab - Realizado'!B:C,2,0),\"\")","v":"Paulo Vitor"},null,null,{"$f":"IFERROR(VLOOKUP(C8,'Colab - Previsto'!B:D,3,0),\"\")","v":6789},{"$f":"IFERROR(VLOOKUP(C8,'Colab - Previsto'!B:F,5,0),\"\")","v":"Almoxarife"}]
[]
[null,null,"Cód.","Descrição",null,null,"Referência","Vencimentos",null,null,"Descontos"]
[]
[null,1,101,"SALARIO",null,null,"30 d",{"$f":"IFERROR(SUMIFS('Colab - Realizado'!G14:G63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!A8),\"\")","v":1500}]
[null,2,973,"INSS",null,null,{"$f":"IFERROR(VLOOKUP(E38,CG!$B$16:$C$19,2,1),\"\")","v":""},null,null,null,{"$f":"IFERROR(SUMIFS('Colab - Realizado'!Q14:Q63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!A8),\"\")","v":155.96590909090909}]
[null,3,987,"IRFF S.SALARIO",null,null,{"$f":"IFERROR(VLOOKUP(I38,CG!E16:F20,2,1),\"\")","v":0},null,null,null,{"$f":"IFERROR(SUMIFS('Colab - Realizado'!R14:R63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!A8),\"\")","v":1.4684659090908951}]
[null,4,123,"HORA EXTRA 50%",null,null,{"$f":"IFERROR(SUMIFS('Colab - Realizado'!I14:I63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!H5),\"\")","v":0},{"$f":"(C38/220)*G15*1.5","v":0}]
[null,5,124,"HORA EXTRA 100%",null,null,{"$f":"IFERROR(SUMIFS('Colab - Realizado'!J14:J63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!H5),\"\")","v":0},{"$f":"(C38/220)*G16*2","v":0}]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,"_____/_____/_____","DATA"]
[null,15]
[null,16]
[null,17]
[null,18]
[]
[null,null,null,null,null,null,null,"Total de Vencimentos",null,null,"Total de Descontos"]
[null,null,null,null,null,null,null,{"$f":"SUM(H12:J29)","v":1500},null,null,{"$f":"SUM(K13:M29)","v":157.43437499999999}]
[]
[null,null,null,null,null,null,null,"Valor Líquido",null,null,{"$f":"H32-K32","v":1342.565625}]
[]
[]
[null,null,"Salário Base",null,"Sal. Contr. INSS","Base Cálc. FGTS","FGTS do Mês",null,"Base Cálc. IRRF"]
[null,null,{"$f":"IFERROR(SUMIFS('Colab - Realizado'!G14:G63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!H5),\"\")","v":0},null,{"$f":"IFERROR(SUMIFS('Colab - Realizado'!P14:P63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!H5),\"\")","v":0},{"$f":"IFERROR(SUMIFS('Colab - Realizado'!P14:P63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!H5),\"\")","v":0},{"$f":"F38*0.08","v":0},null,{"$f":"IFERROR(SUMIFS('Colab - Realizado'!P14:P63,'Colab - Realizado'!B14:B63,Holerite!C8,'Colab - Realizado'!X14:X63,Holerite!H5),\"\")","v":0}]
[]
[]
[null,"- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - corte arqui - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -"]
[]
[]
[null,null,{"$f":"IF(C3=\"\",\"\",C3)","v":"Empresa ABCDE"},null,null,null,"Recibo de Pagamento de Salário",null,null,null,null,null,null,null,"DECLARO TER RECEBIDO  A I MPOTÂNCIA LÍQUIDA DISCRIMINADA NESTE RECIBO\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"________________________________"]
[null,null,{"$f":"IF(C5=\"\",\"\",C5)","v":"CNPJ: "},null,null,null,null,{"$f":"H5","v":"Janeiro"},null,null,"/",{"$f":"L5","v":2021},null,null,null,null,"ASSINATURA DO FUNCIONÁRIO"]
[]
[null,null,"Código","Nome do Funcionário",null,null,"CBO","Função"]
[null,null,{"$f":"IF(C8=\"\",\"\",C8)","v":9003},{"$f":"IF(D8=\"\",\"\",D8)","v":"Paulo Vitor"},null,null,{"$f":"IF(G8=\"\",\"\",G8)","v":6789},{"$f":"IF(H8=\"\",\"\",H8)","v":"Almoxarife"}]
[]
[null,null,"Cód.","Descrição",null,null,"Referência","Vencimentos",null,null,"Descontos"]
[]
[null,null,{"$f":"IF(C12=\"\",\"\",C12)","v":101},{"$f":"IF(D12=\"\",\"\",D12)","v":"SALARIO"},null,null,{"$f":"IF(G12=\"\",\"\",G12)","v":"30 d"},{"$f":"IF(H12=\"\",\"\",H12)","v":1500},null,null,{"$f":"IF(K12=\"\",\"\",K12)","v":""}]
[null,null,{"$f":"IF(C13=\"\",\"\",C13)","v":973},"INSS",null,null,{"$f":"IF(G13=\"\",\"\",G13)","v":""},"",null,null,{"$f":"IF(K13=\"\",\"\",K13)","v":155.96590909090909}]
[null,null,987,"IRFF S.SALARIO",null,null,0,"",null,null,{"$f":"IF(K14=\"\",\"\",K14)","v":1.4684659090908951}]
[null,null,123,"HORA EXTRA 50%",null,null,0,0,null,null,{"$f":"IF(K15=\"\",\"\",K15)","v":""}]
[null,null,124,"HORA EXTRA 100%",null,null,0,0,null,null,{"$f":"IF(K16=\"\",\"\",K16)","v":""}]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,"",null,null,null,null,"_____/_____/_____","DATA"]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,"","",null,null,"","",null,null,""]
[null,null,{"$f":"IF(C29=\"\",\"\",C29)","v":""},{"$f":"IF(D29=\"\",\"\",D29)","v":""},null,null,{"$f":"IF(G29=\"\",\"\",G29)","v":""},{"$f":"IF(H29=\"\",\"\",H29)","v":""},null,null,""]
[]
[null,null,null,null,null,null,null,"Total de Vencimentos",null,null,"Total de Descontos"]
[null,null,null,null,null,null,null,{"$f":"IF(H32=\"\",\"\",H32)","v":1500},null,null,{"$f":"IF(K32=\"\",\"\",K32)","v":157.43437499999999}]
[]
[null,null,null,null,null,null,null,"Valor Líquido",null,null,{"$f":"IF(K34=\"\",\"\",K34)","v":1342.565625}]
[]
[]
[null,null,"Salário Base",null,"Sal. Contr. INSS","Base Cálc. FGTS","FGTS do Mês",null,"Base Cálc. IRRF"]
[null,null,{"$f":"IF(C38=\"\",\"\",C38)","v":0},null,{"$f":"IF(E38=\"\",\"\",E38)","v":0},{"$f":"IF(F38=\"\",\"\",F38)","v":0},{"$f":"IF(G38=\"\",\"\",G38)","v":0},null,{"$f":"IF(I38=\"\",\"\",I38)","v":0}]

{"sheet":"Dash","index":6,"n_rows":88,"n_cols":8,"rows_kept":88,"cut":false,"hidden":false,"merged":[[10,2,10,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Empresa:",{"$f":"CG!C10","v":"Empresa ABCDE"}]
[]
[]
[null,"Salário Líquido Total:",{"$f":"SUM('Colab - Realizado'!U14:U63)","v":6963.0414772727272}]
[]
[null,"Total INSS:",{"$f":"SUM('Colab - Realizado'!Q14:Q63)","v":768.47727272727275}]
[]
[null,"Total IR:",{"$f":"SUM('Colab - Realizado'!R14:R63)","v":101.4357954545454}]
[]
[null,"Total Hora Extra:",{"$f":"SUM('Colab - Realizado'!K14:K63)","v":382.9545454545455}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rótulos de Linha","Salário Líquido ","Hora Extra",null,"Rótulos de Linha","Salário Líquido ","Hora Extra"]
[null,"Administrativo",3257.55,1380.681818181818,null,"João Alves",1127.6590909090908,19.09090909090909]
[null,"Almoxarifado",1825.8238636363635,23.863636363636363,null,"José da Silva",3257.55,1380.681818181818]
[null,"Produção",1127.6590909090908,19.09090909090909,null,"Paulo Vitor",1825.8238636363635,23.863636363636363]
[null,"(vazio)",0,0,null,"(vazio)",0,0]
[null,"Total Geral",6211.0329545454542,1423.6363636363633,null,"Total Geral",6211.0329545454551,1423.6363636363633]

{"sheet":"Instruções","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Lista","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Janeiro",null,2021]
["Fevereiro",null,2022]
["Março",null,2023]
["Abril",null,2024]
["Maio",null,2025]
["Junho",null,2026]
["Julho",null,2027]
["Agosto",null,2028]
["Setembro",null,2029]
["Outubro",null,2030]
["Novembro"]
["Dezembro"]